To Remove Replica References from the Master DB

To unsuscribe the user

Whenever a laptop is no longer going to be used to run the replication database, snapshot references corresponding to the laptop for replication should be removed from the Master database.

At the command prompt, run the UNSUBSCRIBEUSER.BAT utility, from ..\Program Files\Bentley\UtilitiesDesigner\, with the following parameters. Use parameters in the order specified and use a space to separate each value.
Cmd:\> UnSubscribeUser <Server Name> <Master DB Instance> <Master User> <Master Password> <Repository DB Instance> <Repository User> <Repository Password> <Unique Name > < Workflow Manager Username>
Where:
- Host name of the Master Oracle Server database
- Oracle SID of the Master database
- Username for connecting to Master database
  Note: This user name must exist in the Userlogin table of the Master database and in the Mobile Server prior to running the batch file.
- Password for the Master User
- Oracle SID of the Repository database (Usually the same as Master database)
- Username for Repository user (Usually MOBILEADMIN)
- Password for the Repository User
- A name for the Workflow Manager Replication Publication
  Note: This name must be only two characters.
- Workflow Manager User name of the user who is going to the use the replication database
For Example: Cmd:\> UnSubscribeUser geobox elecxm chdata chadmin elecxm mobileadmin chadmin WM administrator

To unsubscribe all users

Whenever the entire replication setup is to be cleanedup all the snapshot references corresponding for replication should be removed from the Master database.

At the command prompt, run the UNSUBSCRIBEALL.BAT utility, from ..\Program Files\Bentley\UtilitiesDesigner\, with the following parameters. Use parameters in the order specified and use a space to separate each value.
Cmd:\> UnSubscribeAll <Server Name> <Master DB Instance> <Master User> <Master Password> <Repository DB Instance> <Repository User> <Repository Password> <Unique Name>
Where:
- Host name of the Master Oracle Server database
- Oracle SID of the Master database
- Username for connecting to Master database
- Password for the Master User
- Oracle SID of the Repository database (Usually the same as Master database)
- Username for Repository user (Usually MOBILEADMIN
- Password for the Repository User
- A name for the Workflow Manager Replication Publication.
  Note: This name must be only two characters. For Example: Cmd:\> UnSubscribeAll geobox elecxm chdata chadmin elecxm mobileadmin chadmin WM

To drop the entire publication

Whenever the entire replication setup is to be cleanedup all the snapshot references corresponding for replication should be removed from the Master database. Before dropping the entire publication, all the users must be unsubscribed from the publication.

At the command prompt, run the DROPPUBLICATION.BAT utility, from ..\Program Files\Bentley\UtilitiesDesigner\, with the following parameters. Use parameters in the order specified and use a space to separate each value.
Cmd:\> DropPublication <Server Name> <Master DB Instance> <Master User> <Master Password> <Repository DB Instance> <Repository User> <Repository Password> <Unique Name>
Where:
- Host name of the Master Oracle Server database
- Oracle SID of the Master database
- Username for connecting to Master database
- Password for the Master User
- Oracle SID of the Repository database (Usually the same as Master database)
- Username for Repository user (Usually MOBILEADMIN)
- Password for the Repository User
- A name for the Workflow Manager Replication Publication.
  Note: This name must be only two characters.
For Example: Cmd:\> DropPublication geobox elecxm chdata chadmin elecxm mobileadmin chadmin WM